Microsoft Office Tools with VBA

1. AND Function
1.1. Syntax Function

   AND (logical1, logical2, ...) : Returns TRUE if all arguments are TRUE, returns FALSE if one or more argument is FALSE
1.2. Example
    Please try type below to your excel sheet and see result detail.

1.3. Explain
     About above example I will explain you reason why
     =AND(H9>100,I9<0) It mean that if cell H9 has value great than 100 also cell I9 has value less than 0 then result TRUE if one arguments is false then Result is FALSE.
1.4. Note
   - You can use and with other function like IF,.. more detail please continue read